Using SAS Software to Analyze Sybase Performance on the Web

This paper provides a web-based system using SAS, HTML and CGI/PERL to provide rudimentary and complex Sybase DBMS performance metrics for Unix based system operations. Sybase SQL Server performance data is collected by Sybase Historical Server allowing for the collection of performance information with minimal impact on the server. The SAS System (Base SAS, Macro, STAT and SAS/Graph) is especially well suited to analyzing and visualizing these data. Its graphical, data mining and statistical capabilities coupled with its ability to access data from a multitude of formats, including DBMS, PC and ASCII files, provides an all in one performance analysis toolkit. In this paper, we present a World Wide Web interface to exploit the power of SAS processing for open system delivery of information. The SAS system processes calculations much faster than the functions supplied with DBMS technology. SAS Access to Sybase SQL Pass through facility allows the use of DBMS data access technology. Therefore, this approach exploits the strengths of two technologies to optimize information delivery. The skill level for SAS programmers requires an intermediate to advanced programmer track.